package com.apes.scm.stock.transfer.repository;

import com.apes.framework.jpa.repository.CustomRepository;
import com.apes.scm.stock.transfer.model.TransferItem;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @author xul
 * @create 2018-01-23 16:07
 */
public interface TransferItemRepository extends CustomRepository<TransferItem, Long> {
    @Query(value = "SELECT T FROM TransferItem T WHERE transfer.id = ?1 order by product.name asc ")
    List<TransferItem> findTransferId(String transferId);
}
